<template>
  <view>
    <view class="uni-header">
      <view class="uni-group">
        <view class="uni-title">部门列表</view>
        <view class="uni-sub-title">展示所有部门</view>
          <button class="uni-button" type="default" size="mini" @click="navBack">返回</button>
      </view>
      <view class="uni-group">
        <input class="uni-search" type="text" v-model="query" @confirm="search" placeholder="请输入名称搜索" />
        <button class="uni-button" type="default" size="mini" @click="search">搜索</button>
        <button class="uni-button" type="default" size="mini" @click="navigateTo('./add')">新增</button>
        <download-excel class="hide-on-phone" :fields="exportExcel.fields" :data="exportExcelData"
          :type="exportExcel.type" :name="exportExcel.filename">
          <button class="uni-button" type="primary" size="mini">导出 Excel</button>
        </download-excel>
      </view>
    </view>
    <view class="uni-container">
      <unicloud-db ref="udb" :collection="collectionList" field="name,type,parent_id,create_date,update_date,description" :where="where"
        page-data="replace" :orderby="orderby" :getcount="true" :page-size="options.pageSize"
        :page-current="options.pageCurrent" v-slot:default="{ data, pagination, loading, error, options }" :options="options"
        loadtime="manual" @load="onqueryload">
        <uni-table ref="table" :loading="loading" :emptyText="error.message || '没有更多数据'" border stripe>
          <uni-tr>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'name')" sortable
              @sort-change="sortChange($event, 'name')">名称</uni-th>
            <uni-th align="center">描述</uni-th>
			<uni-th align="center">创建时间</uni-th>
			<uni-th align="center">最后修改时间</uni-th>
            <uni-th align="center">操作</uni-th>
          </uni-tr>
          <uni-tr v-for="(item, index) in data" :key="index">
            <uni-td align="center"><text @click="searchChilds(item._id)" :class="{'text-underline': item.type == 'department'}">{{ item.name }}</text></uni-td>
            
            <uni-td align="center">{{ item.description }}</uni-td>
			<uni-td align="center">
			  <uni-dateformat :threshold="[0, 0]" :date="item.create_date"></uni-dateformat>
			</uni-td>
			<uni-td align="center">
			  <uni-dateformat :threshold="[0, 0]" :date="item.update_date"></uni-dateformat>
			</uni-td>
            <uni-td align="center">
              <view class="uni-group">
                <button @click="navigateTo(`./add?parent_id=${item._id}&type=${item.type}`, false)" class="uni-button" size="mini" type="primary">添加下级</button>
				<button @click="navigateTo('../mydb-employee/add?department_id=' + item._id, false)" class="uni-button" size="mini">添加员工</button>
                <button @click="navigateTo(`./edit?id=${item._id}&type=${item.type}`, false)" class="uni-button" size="mini">修改</button>
                <button @click="confirmDelete(item._id)" class="uni-button" size="mini" type="warn">删除</button>
              </view>
            </uni-td>
          </uni-tr>
        </uni-table>
        <view class="uni-pagination-box">
          <uni-pagination show-icon :page-size="pagination.size" v-model="pagination.current" :total="pagination.count"
            @change="onPageChanged" />
        </view>
      </unicloud-db>
    </view>
  </view>
</template>

<script>
import { enumConverter, filterToWhere } from '../../js_sdk/validator/mydb-department.js';

const db = uniCloud.database()
// 表查询配置
const dbOrderBy = '' // 排序字段
const dbSearchFields = ['name'] // 模糊搜索字段，支持模糊搜索的字段列表。联表查询格式: 主表字段名.副表字段名，例如用户表关联角色表 role.role_name
// 分页配置
const pageSize = 20
const pageCurrent = 1

const orderByMapping = {
  "ascending": "asc",
  "descending": "desc"
}

export default {
  data() {
    return {
      collectionList: "mydb-department",
      query: '',
      where: 'type == "department"',
      orderby: dbOrderBy,
      orderByFieldName: "",
      selectedIndexs: [],
      filter: {
        type: 'department'
      },
      options: {
        pageSize,
        pageCurrent,
        filterData: {
          "type_localdata": [
            {
              "value": "department",
              "text": "部门"
            },
            {
              "value": "team",
              "text": "小组"
            },
            {
              "value": "store",
              "text": "门店"
            },
            {
              "value": "employee",
              "text": "员工"
            }
          ]
        },
        ...enumConverter
      },
      imageStyles: {
        width: 64,
        height: 64
      },
      exportExcel: {
        "filename": "部门.xls",
        "type": "xls",
        "fields": {
          "部门名称": "name",
          "部门描述": "description",
        }
      },
      exportExcelData: []
    }
  },
  onLoad(e) {
    this._filter = {}
	if(e.parent_id){
		this.where = 'parent_id == "' + e.parent_id + '"'
	}
  },
  onReady() {
    this.$refs.udb.loadData()
  },
  methods: {
    searchChilds(id) {
      uni.navigateTo({
      	url:`/pages/mydb-department/list?parent_id=${id}`
      })
    },
    onqueryload(data) {
      this.exportExcelData = data
    },
    getWhere() {
      const query = this.query.trim()
      if (!query) {
        return ''
      }
      const queryRe = new RegExp(query, 'i')
      return dbSearchFields.map(name => queryRe + '.test(' + name + ')').join(' || ')
    },
    search() {
      const newWhere = this.getWhere()
      this.where =  newWhere ? 'type == "department" &&' + newWhere : this.where
      this.$nextTick(() => {
        this.loadData()
      })
    },
    loadData(clear = true) {
      this.$refs.udb.loadData({
        clear
      })
    },
    onPageChanged(e) {
      this.selectedIndexs.length = 0
      this.$refs.table.clearSelection()
      this.$refs.udb.loadData({
        current: e.current
      })
    },
    navigateTo(url, clear) {
      // clear 表示刷新列表时是否清除页码，true 表示刷新并回到列表第 1 页，默认为 true
      uni.navigateTo({
        url,
        events: {
          refreshData: () => {
            this.loadData(clear)
          }
        }
      })
    },
	navBack(){
		uni.navigateBack()
	},
    // 多选处理
    selectedItems() {
      var dataList = this.$refs.udb.dataList
      return this.selectedIndexs.map(i => dataList[i]._id)
    },
    // 批量删除
    delTable() {
      this.$refs.udb.remove(this.selectedItems(), {
        success: (res) => {
          this.$refs.table.clearSelection()
        }
      })
    },
    // 多选
    selectionChange(e) {
      this.selectedIndexs = e.detail.index
    },
    confirmDelete(id) {
      this.$refs.udb.remove(id, {
        success: (res) => {
          this.$refs.table.clearSelection()
        }
      })
    },
    sortChange(e, name) {
      this.orderByFieldName = name;
      if (e.order) {
        this.orderby = name + ' ' + orderByMapping[e.order]
      } else {
        this.orderby = ''
      }
      this.$refs.table.clearSelection()
      this.$nextTick(() => {
        this.$refs.udb.loadData()
      })
    },
    filterChange(e, name) {
      this._filter[name] = {
        type: e.filterType,
        value: e.filter
      }
      let newWhere = filterToWhere(this._filter, db.command)
      if (Object.keys(newWhere).length) {
        this.where = newWhere
      } else {
        this.where = ''
      }
      this.$nextTick(() => {
        this.$refs.udb.loadData()
      })
    }
  }
}
</script>

<style scoped>
.text-underline {
  text-decoration: underline;
  cursor: pointer;
  color: #007AFF;
}
</style>
